/*
 Navicat Premium Data Transfer

 Source Server         : ALIYUN
 Source Server Type    : MySQL
 Source Server Version : 50718
 Source Host           : rm-2ze2k9cv5qfo1q0capo.mysql.rds.aliyuncs.com
 Source Database       : first-project

 Target Server Type    : MySQL
 Target Server Version : 50718
 File Encoding         : utf-8

 Date: 12/28/2017 16:27:41 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `userinfo`
-- ----------------------------
DROP TABLE IF EXISTS `userinfo`;
CREATE TABLE `userinfo` (
  `userId` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `userName` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `password` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `userType` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `createTime` datetime DEFAULT NULL,
  `lastLoginTime` datetime DEFAULT NULL,
  `loginIp` varchar(255) COLLATE utf8_bin DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
--  Records of `userinfo`
-- ----------------------------
BEGIN;
INSERT INTO `userinfo` VALUES ('1', 'xtian.zhuang', 'xtian.zhuang', '1', '2017-12-27 00:00:00', '2017-12-27 00:00:00', '127.0.0.1');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
